2016-02-04 - 24697.100 - Spec - UPCs reusability #CrystalReportDevelopment
SPECIFICATION
24697.100 - UPC Recycle Report
Purpose
Need to Identify materials can be deleted, free up UPCs from those materials.
Admin Info
Purpose
|
Need to Identify materials can be deleted, free up UPCs from those materials.
|
Requested By
|
Dave Heimburg
|
Spec Created By
|
Venkateswara Reddy D
|
Spec Created Date
|
02-04-2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
MARA,VBAP,VBUK,MSEG,MKPF,MEAN,MVKE,MAKT
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
24
|
2
|
Documentation
|
12
|
3
|
Development/ Config
|
60
|
4
|
Testing
|
24
|
5
|
Report Processing
|
30
|
5
|
File Processing
|
30
|
|
TOTAL
|
180
|
References
Prior Tickets
None
Documents
UPC Recycle Report.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Need to get the materials by input parameter Material group 5
|
Babu Lankipalli
|
03/11/2016
|
Create parameter for material group 5 due to report failure for running the report for multiple category values.
|
2
|
Need to remove the table MKPF.
|
Babu Lankipalli
|
03/18/2016
|
Filter the Materials by suppressing the Material document year in MSEG table instead of hitting the MKPF table.
|
3
|
Remove the materials if the sales document date is > 03/01/2013.
|
Babu Lankipalli
|
04/11/2016
|
Need to remove the materials if the sales document is greater than required document date.
|
Functional Requirement
Purpose/WHY:
Need to Identify if materials can be deleted, free up UPCs from those material
In Scope:
Need to develop the two reports to get the materials that can be deleted and free up UPCs from those materials.
Out of Scope:
All Materials for which the Sales Orders have been created after 03/31/2013.
Solution Summary
UPC Reycle Report1
1. Need to get the material number from MARA table by input the parameters creation data and material group 5.
2. Need to establish the link between the tables.
3. Need to filter the data by following conditions:
i) Need to filter the data if overall processing status of document is equal to 'C'.
ii) Need to filter the data from MVKE table when the Sales org is not equal to '1000'.
4. Need to generate the .xls file.
5. Need to filter the data if the sales document date is greater than given sales document date.
UPC Recycle Report2
1. Need to generate the link between .xls file(UPC Recycle Report1) to MSEG table.
2. Need to filter the data if the material document year greater than parameter value "Document year".
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Development server.
|
Report should execute successfully in NEC BI Development server.
|
Solution Details
UPC Reycle Report1
1. Need to get the material number from MARA table by input the parameters creation data and material group 5.
2. Need to establish the link between the tables.
3. Need to filter the data by following conditions:
i) Need to filter the data if overall processing status of document is equal to 'C'.
ii) Need to filter the data from MVKE table when the Sales org is not equal to '1000'.
4. Need to generate the .xls file.
5. Need to filter the data if the sales document date is greater than given sales document date.
UPC Recycle Report2
1. Need to generate the link between .xls file(UPC Recycle Report1) to MSEG table.
2. Need to filter the data if the material document year greater than parameter value "Document year".
Issues
1. Huge volume of data in the NEP tables resulted in performance issue.
2. Report failure when we run the report for more than one year data.